package com.weixin.service;

import java.sql.SQLException;
import java.util.List;

import com.weixin.entity.Student;
import com.weixin.entity.User;

public interface StudentService {
	  public List<Student> findAll() throws SQLException;
      public Student findByid(int s_id) throws SQLException;
      public boolean removeByid(int u_id) throws SQLException;
      public boolean add(Student student) throws SQLException;
      public boolean update(Student student) throws SQLException;
      public User select(String name,String password) throws SQLException;
      public List<User> ListByrole(String role) throws SQLException;
      public List<User> ListAllBypage(String role,int pageNum,int pageSize) throws SQLException;
      public int getTotal(String role) throws SQLException;
      public List<User> selectAllSearch(String role,String search,int pageNum,int pageSize) throws SQLException;
      public int selectAllTotalSearch(String role,String search) throws SQLException;
}
